UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'taYUdGGtX/LWlfJp5xHF3dNFf99TBW43UBEBBZlyw3M='
WHERE
key_id = '768da9c3d7ad8362b94b0c6afde033c67ad9d241d127f8343cfee90a505cf730'
AND (
token = 'taYUdGGtX/LWlfJp5xHF3dNFf99TBW43UBEBBZlyw3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)