UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dMHpE8YoCmRQjAc9gp2KO0Fpqwis2dfkEfs02m8XWao='
WHERE
key_id = '26bdf4687dc5d4038c506389c6f482b28387a260da93b3ebe2946cecb851acd5'
AND (
token = 'dMHpE8YoCmRQjAc9gp2KO0Fpqwis2dfkEfs02m8XWao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)