UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c9upjAEW2DEBOhMx54cG6RxLrLfjrdUfy714njCVPrw='
WHERE
key_id = '457154b414691dbb9ceb65b1ba536dabc5308a55292b903da3e2b2d7725810a2'
AND (
token = 'c9upjAEW2DEBOhMx54cG6RxLrLfjrdUfy714njCVPrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)