UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4zWcTM8aNRK0RVE9RgSjCBtVt2T6abtIr7Plg+Kpck8='
WHERE
key_id = '10d2973ac5160f220e1c653a86deb9c71d90c572441a5e36471caf9c278619c2'
AND (
token = '4zWcTM8aNRK0RVE9RgSjCBtVt2T6abtIr7Plg+Kpck8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)