UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sGa1aaWc/lOALCz3G7mQeIE/EbXHBGUsETJlwuv+fpY='
WHERE
key_id = 'a579ababeb9ca65b0dff768138ebc06fc3dfc179ed97ce39449ddd9ff10ec2c4'
AND (
token = 'sGa1aaWc/lOALCz3G7mQeIE/EbXHBGUsETJlwuv+fpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)