UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ipsTQdHoBuBXveMvfOV7v5J2wgY8nmPIgRDEzck+OKI='
WHERE
key_id = '054186f74f52bf8f24669b44cc7282cbd8f3c8e55234750dda7221e67acaa6eb'
AND (
token = 'ipsTQdHoBuBXveMvfOV7v5J2wgY8nmPIgRDEzck+OKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)