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