UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LN9iUw8/gBggJl4uddVjyvlk2C/Olsy8+03R5fRBHZk='
WHERE
key_id = 'b57f52ec50732a2d872743ec12e6b575001bde6ca25bd68e70d5a999bd4cbf87'
AND (
token = 'LN9iUw8/gBggJl4uddVjyvlk2C/Olsy8+03R5fRBHZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)