UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jX/W3YZQAX6MTjw+TqZy5JtJVpMvoOWZZo35XddUCsc='
WHERE
key_id = '81b9132598a827bd7e16f031fc87da66c8d95f1b093c51625c1f9a32b23ba858'
AND (
token = 'jX/W3YZQAX6MTjw+TqZy5JtJVpMvoOWZZo35XddUCsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)