UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9HMJubfFeF+c6Fi1fTBgaQ/uOv6XBOAUIF9oDdCWIYM='
WHERE
key_id = '1ef1733521f3261a9f10a33d3ce0c089f52fb5813e6da013611e69e61be6ff8f'
AND (
token = '9HMJubfFeF+c6Fi1fTBgaQ/uOv6XBOAUIF9oDdCWIYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)