UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oEt13DtTllQ43XtJsAf4TOo0UR2YPQL52UKAPnMN9tU='
WHERE
key_id = 'd710aa9e01a432f11cf21eb122c53c6f0b84b84750043d63547fc75be35b0a7b'
AND (
token = 'oEt13DtTllQ43XtJsAf4TOo0UR2YPQL52UKAPnMN9tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)