UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3OfxaKqyRvrTCKIAq5Fvfi2+WH1dcpX7zlpBoILVwq0='
WHERE
key_id = 'b43c6f82c25b0e3a6f098e6eaad9b31b3657dcb3ea2206a77909fb58fac00b22'
AND (
token = '3OfxaKqyRvrTCKIAq5Fvfi2+WH1dcpX7zlpBoILVwq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)