UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rWHVJ6SBKroP9uoUvByEVi6sjoI3y518I5I1R7L8DU='
WHERE
key_id = '005f16b9476f1d61e2e096500d4983abac1cd624dcde2dffd325b696af4134d6'
AND (
token = '8rWHVJ6SBKroP9uoUvByEVi6sjoI3y518I5I1R7L8DU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)