UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1B/0iiwbJ1j9mPvvd/z8m4bRfVE/J9IT4oooI+Uznq0='
WHERE
key_id = '1b3de60bde9edd9c8a91f5058ac3667acd643356dd2e18b0a85be4c69304e781'
AND (
token = '1B/0iiwbJ1j9mPvvd/z8m4bRfVE/J9IT4oooI+Uznq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)