UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4LzQRMLzlt4PfA9sA1Z/8jsPNIBTqLr4tLrm2q8GyI0='
WHERE
key_id = '9d4cb085c64574c16b961dc37bea51451511b81feff9842102ed8d6ca289a401'
AND (
token = '4LzQRMLzlt4PfA9sA1Z/8jsPNIBTqLr4tLrm2q8GyI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)