UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MIRBDcdcmpoW15Z6t12AVu/88qfOw7FjfW1GYIeYHHg='
WHERE
key_id = 'e19a8c945909cf0c63ff8b99931d7976a87095a68829a3e037a1885452e2c1fe'
AND (
token = 'MIRBDcdcmpoW15Z6t12AVu/88qfOw7FjfW1GYIeYHHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)