UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6BdkGaHPyXWn19PbDCBGRlqiAKlWvBJGHk2X7VHCUg='
WHERE
key_id = '114a61becd04e98775acf5b3fa52ac2c4385193e2d68ed7261e3513112e2ca55'
AND (
token = 'p6BdkGaHPyXWn19PbDCBGRlqiAKlWvBJGHk2X7VHCUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)