UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K20kzdgZD99OiwDcDzBoGhgMsb2lS3k7vYN/ec6ybD8='
WHERE
key_id = 'c148fbc84bf9dd268a95c27ce282600399e38cbf14d5b5afacd6572e8d8f9102'
AND (
token = 'K20kzdgZD99OiwDcDzBoGhgMsb2lS3k7vYN/ec6ybD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)