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