UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hXyPwpVmn6Aha3tdj1AB4kHJLY0HVJtElI7W9V4KIlE='
WHERE
key_id = 'd98c7d5f6ac689170fcd27931f7b3b44b13a61ab017cae0a4683a7f3c7e097a7'
AND (
token = 'hXyPwpVmn6Aha3tdj1AB4kHJLY0HVJtElI7W9V4KIlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)