UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uK8KJXMUzOtmz8pCYzjtPtH+8LSIdbkvyoaksXp51dA='
WHERE
key_id = '5230f6afc419d6a8c6d94ef535fc58385305159212c3792e2f647d468001306b'
AND (
token = 'uK8KJXMUzOtmz8pCYzjtPtH+8LSIdbkvyoaksXp51dA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)