UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgvIgSBpKeN9rQtIzym0lcD1M1cmVM+qKLiOK+16k7M='
WHERE
key_id = 'f623d64c168c494827f5536968a0f5b486b2c9161c52f2a307ded9c18cd1509c'
AND (
token = 'XgvIgSBpKeN9rQtIzym0lcD1M1cmVM+qKLiOK+16k7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)