UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6C/D8UXxE9Pqc5o40jmyht6q5whRj/8S3Y9VfgSoMqc='
WHERE
key_id = 'f9416a2a6cef61e353360752cc03a06382fba117117a5895185ca123d16a1a62'
AND (
token = '6C/D8UXxE9Pqc5o40jmyht6q5whRj/8S3Y9VfgSoMqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)