UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yipL3qHsgpG9HVvh8YfEbaKPZflKtP3kakwceEuaYcM='
WHERE
key_id = 'e510e4631b072226a278533964d2107350d3059a28d210e7d7d2ac2b42aade1d'
AND (
token = 'yipL3qHsgpG9HVvh8YfEbaKPZflKtP3kakwceEuaYcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)