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