UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KqTRj/+AhaffpJyCanD4RS3hOfJqJtBIaGUEEcw4DIk='
WHERE
key_id = '846307bd7af4ef6801f8416a1f062faefe1ba42dbd8c700dc17f5f7aa94d6f5e'
AND (
token = 'KqTRj/+AhaffpJyCanD4RS3hOfJqJtBIaGUEEcw4DIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)