UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rz5giNdF9/LC6gPtS+Myc1782phfYkobyCC3TMHEKPM='
WHERE
key_id = '7d947d5330fcce7fb1f4b9706f40be0cda0d293cc19f6eb556062ba83da0c1b6'
AND (
token = 'Rz5giNdF9/LC6gPtS+Myc1782phfYkobyCC3TMHEKPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)