UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4wRL8ezJ16vwKmf+/0pEvXWKnzJvIEWTYgFb/sA0Lc='
WHERE
key_id = 'b9d2ec6f4d4768222cbcc8901ce7521bd4bce6a8a396bb5c9766d0b4d716df69'
AND (
token = 'd4wRL8ezJ16vwKmf+/0pEvXWKnzJvIEWTYgFb/sA0Lc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)