UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tUVmMBJvwtdOBaXTCW370Xy26oxDzJvEn405zgIjXo8='
WHERE
key_id = '549b420cefeecebd2dc73652e3d55d0497ad899baf743df967e844135d231ad7'
AND (
token = 'tUVmMBJvwtdOBaXTCW370Xy26oxDzJvEn405zgIjXo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)