UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OZzGXIJxi3eHrUf6/sWSu57/g5mLYiyVtL48qahRl8U='
WHERE
key_id = '0dc28828169b3daa78180874e823205fb13f0bb3f326d11cc2ba5069b197bce7'
AND (
token = 'OZzGXIJxi3eHrUf6/sWSu57/g5mLYiyVtL48qahRl8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)