UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '64zgANhl+dV6qFvrfTgjT41W+O7OlmkZFz7kI2rX+3M='
WHERE
key_id = '48307b08261faff0fe6561dfdc32296b52f38d806f6f8335dbc3b27f9979db3a'
AND (
token = '64zgANhl+dV6qFvrfTgjT41W+O7OlmkZFz7kI2rX+3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)