UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YTDVs3pDkvkjYxK9yqmpe7qscLDVvfuOATJzpkxl+Vo='
WHERE
key_id = 'a80bb1217c524cf0d3578112f25cd1d179bf92547f0daa27571f76b96495eee6'
AND (
token = 'YTDVs3pDkvkjYxK9yqmpe7qscLDVvfuOATJzpkxl+Vo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)