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