UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4htbjK2CJusKoTFM8y4cj4frzNycqqp3ZwfAR8wnd9E='
WHERE
key_id = 'b8b032439fd37823c157d04fd972816494f7ebd7ce90d171e05f91f5ee33b917'
AND (
token = '4htbjK2CJusKoTFM8y4cj4frzNycqqp3ZwfAR8wnd9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)