UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z0TlvPA2zzFhrTgJSY+vkay291vdBZ1IvVXnKre43ts='
WHERE
key_id = 'c6171fbfee7808d70f61b8eea943e63758c383e9423f4203e552a077510ef7d8'
AND (
token = 'Z0TlvPA2zzFhrTgJSY+vkay291vdBZ1IvVXnKre43ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)