UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/BOixKjG1BocbU7xkwZny58z4xSWk64xY4XvKy+U1vE='
WHERE
key_id = '7a1af59cfefa93a5a8c9e4601a73ade66cd6b07bd35fd3e93968029baf2aef8a'
AND (
token = '/BOixKjG1BocbU7xkwZny58z4xSWk64xY4XvKy+U1vE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)