UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prfI4vHN2TgWV8ezGl7I9ROuUKnRjOJtGgn0Lp0npVc='
WHERE
key_id = '872e8876ba31aa65de9d691dc3304d4a76ff966350027f2f26ca9cd5b2d3f292'
AND (
token = 'prfI4vHN2TgWV8ezGl7I9ROuUKnRjOJtGgn0Lp0npVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)