UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EemVo2QP5VDJAdm3mc38PJyVHqjySkrr4RwDCMtIGbM='
WHERE
key_id = '193b2625aecfe82468b172e33c847c93b5579adb7e3740c9d9afb478031fe3c2'
AND (
token = 'EemVo2QP5VDJAdm3mc38PJyVHqjySkrr4RwDCMtIGbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)